/*
 Navicat Premium Dump SQL

 Source Server         : 127.0.0.1
 Source Server Type    : MySQL
 Source Server Version : 50744 (5.7.44)
 Source Host           : 127.0.0.1:3306
 Source Schema         : smart_community

 Target Server Type    : MySQL
 Target Server Version : 50744 (5.7.44)
 File Encoding         : 65001

 Date: 07/08/2025 09:37:17
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sc_system_log
-- ----------------------------
DROP TABLE IF EXISTS `sc_system_log`;
CREATE TABLE `sc_system_log` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'æ—¥å¿—ID',
  `log_level` tinyint(4) NOT NULL COMMENT 'æ—¥å¿—çº§åˆ«ï¼š1-DEBUGï¼Œ2-INFOï¼Œ3-WARNï¼Œ4-ERROR',
  `log_title` varchar(200) DEFAULT NULL COMMENT 'æ—¥å¿—æ ‡é¢˜ï¼Œä½œè€…ï¼šWu.Liang',
  `log_type` tinyint(4) NOT NULL COMMENT 'æ—¥å¿—ç±»åž‹ï¼š1-ç³»ç»Ÿæ—¥å¿—ï¼Œ2-æ“ä½œæ—¥å¿—ï¼Œ3-é”™è¯¯æ—¥å¿—ï¼Œ4-å®‰å…¨æ—¥å¿—',
  `module_name` varchar(50) DEFAULT NULL COMMENT 'æ¨¡å—åç§°',
  `operation_name` varchar(100) DEFAULT NULL COMMENT 'æ“ä½œåç§°',
  `operation_desc` text COMMENT 'æ“ä½œæè¿°',
  `request_url` varchar(255) DEFAULT NULL COMMENT 'è¯·æ±‚URL',
  `request_method` varchar(10) DEFAULT NULL COMMENT 'è¯·æ±‚æ–¹æ³•',
  `request_params` text COMMENT 'è¯·æ±‚å‚æ•°',
  `response_data` text COMMENT 'å“åº”æ•°æ®ï¼Œä½œè€…ï¼šWu.Liang',
  `response_result` text COMMENT 'å“åº”ç»“æžœ',
  `user_id` bigint(20) DEFAULT NULL COMMENT 'æ“ä½œç”¨æˆ·ID',
  `username` varchar(50) DEFAULT NULL COMMENT 'ç”¨æˆ·åï¼Œä½œè€…ï¼šWu.Liang',
  `user_type` varchar(50) DEFAULT NULL COMMENT '用户类型',
  `ip_address` varchar(50) DEFAULT NULL COMMENT 'IPåœ°å€',
  `user_agent` text COMMENT 'ç”¨æˆ·ä»£ç†',
  `execution_time` int(11) DEFAULT NULL COMMENT 'æ‰§è¡Œæ—¶é—´(æ¯«ç§’)',
  `error_message` text COMMENT 'é”™è¯¯ä¿¡æ¯',
  `stack_trace` text COMMENT 'å †æ ˆä¿¡æ¯',
  `log_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT 'æ—¥å¿—æ—¶é—´',
  `status` tinyint(4) DEFAULT '1' COMMENT 'çŠ¶æ€ï¼Œä½œè€…ï¼šWu.Liang',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT 'åˆ›å»ºæ—¶é—´',
  `log_content` text COMMENT 'æ—¥å¿—å†…å®¹ï¼Œä½œè€…ï¼šWu.Liang',
  `operator` varchar(255) DEFAULT NULL COMMENT 'æ“ä½œäººï¼Œä½œè€…ï¼šWu.Liang',
  `operation_time` datetime DEFAULT NULL COMMENT 'æ“ä½œæ—¶é—´ï¼Œä½œè€…ï¼šWu.Liang',
  `create_by` bigint(20) DEFAULT NULL COMMENT 'åˆ›å»ºäººï¼Œä½œè€…ï¼šWu.Liang',
  PRIMARY KEY (`id`),
  KEY `idx_log_level` (`log_level`),
  KEY `idx_log_type` (`log_type`),
  KEY `idx_module_name` (`module_name`),
  KEY `idx_user_id` (`user_id`),
  KEY `idx_log_time` (`log_time`),
  KEY `idx_user_type` (`user_type`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8mb4 COMMENT='ç³»ç»Ÿæ—¥å¿—è¡¨';

-- ----------------------------
-- Records of sc_system_log
-- ----------------------------
BEGIN;
INSERT INTO `sc_system_log` (`id`, `log_level`, `log_title`, `log_type`, `module_name`, `operation_name`, `operation_desc`, `request_url`, `request_method`, `request_params`, `response_data`, `response_result`, `user_id`, `username`, `user_type`, `ip_address`, `user_agent`, `execution_time`, `error_message`, `stack_trace`, `log_time`, `status`, `create_time`, `log_content`, `operator`, `operation_time`, `create_by`) VALUES (1, 1, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '192.168.1.100', NULL, NULL, NULL, NULL, '2025-06-21 20:20:09', 1, '2025-06-21 20:20:09', 'ç”¨æˆ·ç™»å½•æˆåŠŸ', 'admin', '2025-06-21 20:20:09', 1);
INSERT INTO `sc_system_log` (`id`, `log_level`, `log_title`, `log_type`, `module_name`, `operation_name`, `operation_desc`, `request_url`, `request_method`, `request_params`, `response_data`, `response_result`, `user_id`, `username`, `user_type`, `ip_address`, `user_agent`, `execution_time`, `error_message`, `stack_trace`, `log_time`, `status`, `create_time`, `log_content`, `operator`, `operation_time`, `create_by`) VALUES (2, 2, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '192.168.1.100', NULL, NULL, NULL, NULL, '2025-06-21 20:20:09', 1, '2025-06-21 20:20:09', 'ç³»ç»Ÿé…ç½®æ›´æ–°', 'admin', '2025-06-21 20:20:09', 1);
INSERT INTO `sc_system_log` (`id`, `log_level`, `log_title`, `log_type`, `module_name`, `operation_name`, `operation_desc`, `request_url`, `request_method`, `request_params`, `response_data`, `response_result`, `user_id`, `username`, `user_type`, `ip_address`, `user_agent`, `execution_time`, `error_message`, `stack_trace`, `log_time`, `status`, `create_time`, `log_content`, `operator`, `operation_time`, `create_by`) VALUES (3, 3, NULL, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, '2025-06-21 20:20:09', 1, '2025-06-21 20:20:09', 'æ•°æ®åº“å¤‡ä»½å®Œæˆ', 'system', '2025-06-21 20:20:09', 1);
INSERT INTO `sc_system_log` (`id`, `log_level`, `log_title`, `log_type`, `module_name`, `operation_name`, `operation_desc`, `request_url`, `request_method`, `request_params`, `response_data`, `response_result`, `user_id`, `username`, `user_type`, `ip_address`, `user_agent`, `execution_time`, `error_message`, `stack_trace`, `log_time`, `status`, `create_time`, `log_content`, `operator`, `operation_time`, `create_by`) VALUES (4, 2, '分配角色权限', 2, '用户管理', '修改', '更新数据', 'http://127.0.0.1:8001/user/roles/14/permissions', 'POST', '[14,[]]', '{\"code\":200,\"message\":\"分配成功\",\"timestamp\":1753697056795}', '成功', NULL, NULL, NULL, '127.0.0.1', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36', 14, NULL, NULL, '2025-07-28 18:04:17', 1, '2025-07-28 18:04:17', NULL, NULL, '2025-07-28 18:04:17', NULL);
INSERT INTO `sc_system_log` (`id`, `log_level`, `log_title`, `log_type`, `module_name`, `operation_name`, `operation_desc`, `request_url`, `request_method`, `request_params`, `response_data`, `response_result`, `user_id`, `username`, `user_type`, `ip_address`, `user_agent`, `execution_time`, `error_message`, `stack_trace`, `log_time`, `status`, `create_time`, `log_content`, `operator`, `operation_time`, `create_by`) VALUES (5, 2, '分配角色权限', 2, '用户管理', '修改', '更新数据', 'http://127.0.0.1:8001/user/roles/14/permissions', 'POST', '[14,[13001,13011,13061,13012,13041,13042,13043,13013,13051,13052,13053,13054,13014,13071,13015,13016,12073,13002,13021,13022,13023,13024,13025,13026,13027,12074,12075,12076,12077,12078,12079,12080,13003,13031,13032,13033,13034,13035,13036,13037,13038,12081,12082,12083,12084,12085,12086,13081,13082,13083,13084,13085,12087,12088,12089,12090,12091,12092,12093,12094,13091,12095,12096,12097,12098,12099,12100,12101,12102,12103,13092,12104,12105,12106,12107,12072,12132,12133,12134,12108,12109,12110,12111,12112,12113,12114,12115,12116,12117,12118,12119,12120,12121,12122,12123,12124,12125,12126,12127,12128,12129,12130,12131]]', '{\"code\":200,\"message\":\"分配成功\",\"timestamp\":1753697406895}', '成功', NULL, NULL, NULL, '127.0.0.1', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36', 40, NULL, NULL, '2025-07-28 18:10:07', 1, '2025-07-28 18:10:07', NULL, NULL, '2025-07-28 18:10:07', NULL);
INSERT INTO `sc_system_log` (`id`, `log_level`, `log_title`, `log_type`, `module_name`, `operation_name`, `operation_desc`, `request_url`, `request_method`, `request_params`, `response_data`, `response_result`, `user_id`, `username`, `user_type`, `ip_address`, `user_agent`, `execution_time`, `error_message`, `stack_trace`, `log_time`, `status`, `create_time`, `log_content`, `operator`, `operation_time`, `create_by`) VALUES (6, 2, '分配角色权限', 2, '用户管理', '修改', '更新数据', 'http://127.0.0.1:8001/user/roles/14/permissions', 'POST', '[14,[13001,13011,13061,13012,13041,13042,13043,13013,13051,13052,13053,13054,13014,13071,13015,13016,12073,13002,13021,13022,13023,13024,13025,13026,13027,12074,12075,12076,12077,12078,12079,12080,13003,13031,13032,13033,13034,13035,13036,13037,13038,12081,12082,12083,12084,12085,12086,13081,13082,13083,13084,13085,12087,12088,12089,12090,12091,12092,12093,12094,13091,12095,12096,12097,12098,12099,12100,12101,12102,12103,13092,12104,12105,12106,12107,12072,12132,12133,12134,12108,12109,12110,12111,12112,12113,12114,12115,12116,12117,12118,12119,12120,12121,12122,12123,12124,12125,12126,12127,12128,12129,12130,12131]]', '{\"code\":200,\"message\":\"分配成功\",\"timestamp\":1753696866913}', '成功', NULL, NULL, NULL, '127.0.0.1', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36', 60, NULL, NULL, '2025-07-28 18:01:07', 1, '2025-07-28 18:01:07', NULL, NULL, '2025-07-28 18:01:07', NULL);
INSERT INTO `sc_system_log` (`id`, `log_level`, `log_title`, `log_type`, `module_name`, `operation_name`, `operation_desc`, `request_url`, `request_method`, `request_params`, `response_data`, `response_result`, `user_id`, `username`, `user_type`, `ip_address`, `user_agent`, `execution_time`, `error_message`, `stack_trace`, `log_time`, `status`, `create_time`, `log_content`, `operator`, `operation_time`, `create_by`) VALUES (7, 2, '分配角色权限', 2, '用户管理', '修改', '更新数据', 'http://127.0.0.1:8001/user/roles/14/permissions', 'POST', '[14,[]]', '{\"code\":200,\"message\":\"分配成功\",\"timestamp\":1753697661584}', '成功', NULL, NULL, NULL, '127.0.0.1', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36', 15, NULL, NULL, '2025-07-28 18:14:22', 1, '2025-07-28 18:14:22', NULL, NULL, '2025-07-28 18:14:22', NULL);
INSERT INTO `sc_system_log` (`id`, `log_level`, `log_title`, `log_type`, `module_name`, `operation_name`, `operation_desc`, `request_url`, `request_method`, `request_params`, `response_data`, `response_result`, `user_id`, `username`, `user_type`, `ip_address`, `user_agent`, `execution_time`, `error_message`, `stack_trace`, `log_time`, `status`, `create_time`, `log_content`, `operator`, `operation_time`, `create_by`) VALUES (8, 2, '分配角色权限', 2, '用户管理', '修改', '更新数据', 'http://127.0.0.1:8001/user/roles/14/permissions', 'POST', '[14,[]]', '{\"code\":200,\"message\":\"分配成功\",\"timestamp\":1753697661584}', '成功', NULL, NULL, NULL, '127.0.0.1', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36', 15, NULL, NULL, '2025-07-28 18:14:22', 1, '2025-07-28 18:14:22', NULL, NULL, '2025-07-28 18:14:22', NULL);
INSERT INTO `sc_system_log` (`id`, `log_level`, `log_title`, `log_type`, `module_name`, `operation_name`, `operation_desc`, `request_url`, `request_method`, `request_params`, `response_data`, `response_result`, `user_id`, `username`, `user_type`, `ip_address`, `user_agent`, `execution_time`, `error_message`, `stack_trace`, `log_time`, `status`, `create_time`, `log_content`, `operator`, `operation_time`, `create_by`) VALUES (9, 2, '分配角色权限', 2, '用户管理', '修改', '更新数据', 'http://127.0.0.1:8001/user/roles/14/permissions', 'POST', '[14,[13001,13011,13061,13012,13041,13042,13043,13013,13051,13052,13053,13054,13014,13071,13015,13016,12073,13002,13021,13022,13023,13024,13025,13026,13027,12074,12075,12076,12077,12078,12079,12080,13003,13031,13032,13033,13034,13035,13036,13037,13038,12081,12082,12083,12084,12085,12086,13081,13082,13083,13084,13085,12087,12088,12089,12090,12091,12092,12093,12094,13091,12095,12096,12097,12098,12099,12100,12101,12102,12103,13092,12104,12105,12106,12107,12072,12132,12133,12134,12108,12109,12110,12111,12112,12113,12114,12115,12116,12117,12118,12119,12120,12121,12122,12123,12124,12125,12126,12127,12128,12129,12130,12131]]', '{\"code\":200,\"message\":\"分配成功\",\"timestamp\":1753698202296}', '成功', NULL, NULL, NULL, '127.0.0.1', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36', 37, NULL, NULL, '2025-07-28 18:23:22', 1, '2025-07-28 18:23:22', NULL, NULL, '2025-07-28 18:23:22', NULL);
INSERT INTO `sc_system_log` (`id`, `log_level`, `log_title`, `log_type`, `module_name`, `operation_name`, `operation_desc`, `request_url`, `request_method`, `request_params`, `response_data`, `response_result`, `user_id`, `username`, `user_type`, `ip_address`, `user_agent`, `execution_time`, `error_message`, `stack_trace`, `log_time`, `status`, `create_time`, `log_content`, `operator`, `operation_time`, `create_by`) VALUES (10, 2, '分配角色权限', 2, '用户管理', '修改', '更新数据', 'http://127.0.0.1:8001/user/roles/14/permissions', 'POST', '[14,[]]', '{\"code\":200,\"message\":\"分配成功\",\"timestamp\":1753708445131}', '成功', 24, 'admin', 'SUPER_ADMIN', '127.0.0.1', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36', 48, NULL, NULL, '2025-07-28 21:14:05', 1, '2025-07-28 21:14:05', NULL, '%E7%B3%BB%E7%BB%9F%E7%AE%A1%E7%90%86%E5%91%98', '2025-07-28 21:14:05', 24);
INSERT INTO `sc_system_log` (`id`, `log_level`, `log_title`, `log_type`, `module_name`, `operation_name`, `operation_desc`, `request_url`, `request_method`, `request_params`, `response_data`, `response_result`, `user_id`, `username`, `user_type`, `ip_address`, `user_agent`, `execution_time`, `error_message`, `stack_trace`, `log_time`, `status`, `create_time`, `log_content`, `operator`, `operation_time`, `create_by`) VALUES (11, 2, '分配角色权限', 2, '用户管理', '修改', '更新数据', 'http://127.0.0.1:8001/user/roles/14/permissions', 'POST', '[14,[13001,13011,13061,13012,13041,13042,13043,13013,13051,13052,13053,13054,13014,13071,13015,13016,12073,13002,13021,13022,13023,13024,13025,13026,13027,12074,12075,12076,12077,12078,12079,12080,13003,13031,13032,13033,13034,13035,13036,13037,13038,12081,12082,12083,12084,12085,12086,13081,13082,13083,13084,13085,12087,12088,12089,12090,12091,12092,12093,12094,13091,12095,12096,12097,12098,12099,12100,12101,12102,12103,13092,12104,12105,12106,12107,12072,12132,12133,12134,12108,12109,12110,12111,12112,12113,12114,12115,12116,12117,12118,12119,12120,12121,12122,12123,12124,12125,12126,12127,12128,12129,12130,12131]]', '{\"code\":200,\"message\":\"分配成功\",\"timestamp\":1753708471322}', '成功', 24, 'admin', 'SUPER_ADMIN', '127.0.0.1', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36', 24, NULL, NULL, '2025-07-28 21:14:31', 1, '2025-07-28 21:14:31', NULL, '%E7%B3%BB%E7%BB%9F%E7%AE%A1%E7%90%86%E5%91%98', '2025-07-28 21:14:31', 24);
INSERT INTO `sc_system_log` (`id`, `log_level`, `log_title`, `log_type`, `module_name`, `operation_name`, `operation_desc`, `request_url`, `request_method`, `request_params`, `response_data`, `response_result`, `user_id`, `username`, `user_type`, `ip_address`, `user_agent`, `execution_time`, `error_message`, `stack_trace`, `log_time`, `status`, `create_time`, `log_content`, `operator`, `operation_time`, `create_by`) VALUES (12, 2, '分配角色权限', 2, '用户管理', '修改', '更新数据', 'http://127.0.0.1:8001/user/roles/14/permissions', 'POST', '[14,[13001,13011,13061,13012,13041,13042,13043,13013,13051,13052,13053,13054,13014,13071,13015,13016,12073,13002,13021,13022,13023,13024,13025,13026,13027,12074,12075,12076,12077,12078,12079,12080,13003,13031,13032,13033,13034,13035,13036,13037,13038,12081,12082,12083,12084,12085,12086,13081,13082,13083,13084,13085,12087,12088,12089,12090,12091,12092,12093,12094,13091,12095,12096,12097,12098,12099,12100,12101,12102,12103,13092,12104,12105,12106,12107,12072,12132,12133,12134,12108,12109,12110,12111,12112,12113,12114,12115,12116,12117,12118,12119,12120,12121,12122,12123,12124,12125,12126,12127,12128,12129,12130,12131]]', '{\"code\":200,\"message\":\"分配成功\",\"timestamp\":1753708471322}', '成功', NULL, NULL, NULL, '127.0.0.1', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36', 24, NULL, NULL, '2025-07-28 21:14:31', 1, '2025-07-28 21:14:31', NULL, NULL, '2025-07-28 21:14:31', NULL);
INSERT INTO `sc_system_log` (`id`, `log_level`, `log_title`, `log_type`, `module_name`, `operation_name`, `operation_desc`, `request_url`, `request_method`, `request_params`, `response_data`, `response_result`, `user_id`, `username`, `user_type`, `ip_address`, `user_agent`, `execution_time`, `error_message`, `stack_trace`, `log_time`, `status`, `create_time`, `log_content`, `operator`, `operation_time`, `create_by`) VALUES (13, 2, '分配角色权限', 2, '用户管理', '修改', '更新数据', 'http://127.0.0.1:8001/user/roles/14/permissions', 'POST', '[14,[]]', '{\"code\":200,\"message\":\"分配成功\",\"timestamp\":1753708479910}', '成功', 24, 'admin', 'SUPER_ADMIN', '127.0.0.1', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36', 5, NULL, NULL, '2025-07-28 21:14:40', 1, '2025-07-28 21:14:40', NULL, '%E7%B3%BB%E7%BB%9F%E7%AE%A1%E7%90%86%E5%91%98', '2025-07-28 21:14:40', 24);
INSERT INTO `sc_system_log` (`id`, `log_level`, `log_title`, `log_type`, `module_name`, `operation_name`, `operation_desc`, `request_url`, `request_method`, `request_params`, `response_data`, `response_result`, `user_id`, `username`, `user_type`, `ip_address`, `user_agent`, `execution_time`, `error_message`, `stack_trace`, `log_time`, `status`, `create_time`, `log_content`, `operator`, `operation_time`, `create_by`) VALUES (14, 2, '分配角色权限', 2, '用户管理', '修改', '更新数据', 'http://127.0.0.1:8001/user/roles/14/permissions', 'POST', '[14,[]]', '{\"code\":200,\"message\":\"分配成功\",\"timestamp\":1753708479910}', '成功', NULL, NULL, NULL, '127.0.0.1', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36', 5, NULL, NULL, '2025-07-28 21:14:40', 1, '2025-07-28 21:14:40', NULL, NULL, '2025-07-28 21:14:40', NULL);
INSERT INTO `sc_system_log` (`id`, `log_level`, `log_title`, `log_type`, `module_name`, `operation_name`, `operation_desc`, `request_url`, `request_method`, `request_params`, `response_data`, `response_result`, `user_id`, `username`, `user_type`, `ip_address`, `user_agent`, `execution_time`, `error_message`, `stack_trace`, `log_time`, `status`, `create_time`, `log_content`, `operator`, `operation_time`, `create_by`) VALUES (15, 2, '分配角色权限', 2, '用户管理', '修改', '更新数据', 'http://127.0.0.1:8001/user/roles/4/permissions', 'POST', '[4,[13001,13011,13061,13012,13041,13042,13043,13013,13051,13052,13053,13054,13014,13071,13015,13016,12073,13002,13021,13022,13023,13024,13025,13026,13027,12074,12075,12076,12077,12078,12079,12080,13003,13031,13032,13033,13034,13035,13036,13037,13038,12081,12082,12083,12084,12085,12086,13081,13082,13083,13084,13085,12087,12088,12089,12090,12091,12092,12093,12094,13091,12095,12096,12097,12098,12099,12100,12101,12102,12103,13092,12104,12105,12106,12107,12072,12132,12133,12134,12108,12109,12110,12111,12112,12113,12114,12115,12116,12117,12118,12119,12120,12121,12122,12123,12124,12125,12126,12127,12128,12129,12130,12131]]', '{\"code\":200,\"message\":\"分配成功\",\"timestamp\":1753721541887}', '成功', NULL, NULL, NULL, '127.0.0.1', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36', 61, NULL, NULL, '2025-07-29 00:52:22', 1, '2025-07-29 00:52:22', NULL, NULL, '2025-07-29 00:52:22', NULL);
INSERT INTO `sc_system_log` (`id`, `log_level`, `log_title`, `log_type`, `module_name`, `operation_name`, `operation_desc`, `request_url`, `request_method`, `request_params`, `response_data`, `response_result`, `user_id`, `username`, `user_type`, `ip_address`, `user_agent`, `execution_time`, `error_message`, `stack_trace`, `log_time`, `status`, `create_time`, `log_content`, `operator`, `operation_time`, `create_by`) VALUES (16, 2, '分配角色权限', 2, '用户管理', '修改', '更新数据', 'http://127.0.0.1:8001/user/roles/4/permissions', 'POST', '[4,[13001,13011,13061,13012,13041,13042,13043,13013,13051,13052,13053,13054,13014,13071,13015,13016,12073,13002,13021,13022,13023,13024,13025,13026,13027,12074,12075,12076,12077,12078,12079,12080,13003,13031,13032,13033,13034,13035,13036,13037,13038,12081,12082,12083,12084,12085,12086,13081,13082,13083,13084,13085,12087,12088,12089,12090,12091,12092,12093,12094,13091,12095,12096,12097,12098,12099,12100,12101,12102,12103,13092,12104,12105,12106,12107,12072,12132,12133,12134,12108,12109,12110,12111,12112,12113,12114,12115,12116,12117,12118,12119,12120,12121,12122,12123,12124,12125,12126,12127,12128,12129,12130,12131]]', '{\"code\":200,\"message\":\"分配成功\",\"timestamp\":1753721541887}', '成功', 24, 'admin', 'SUPER_ADMIN', '127.0.0.1', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36', 61, NULL, NULL, '2025-07-29 00:52:22', 1, '2025-07-29 00:52:22', NULL, '%E7%B3%BB%E7%BB%9F%E7%AE%A1%E7%90%86%E5%91%98', '2025-07-29 00:52:22', 24);
INSERT INTO `sc_system_log` (`id`, `log_level`, `log_title`, `log_type`, `module_name`, `operation_name`, `operation_desc`, `request_url`, `request_method`, `request_params`, `response_data`, `response_result`, `user_id`, `username`, `user_type`, `ip_address`, `user_agent`, `execution_time`, `error_message`, `stack_trace`, `log_time`, `status`, `create_time`, `log_content`, `operator`, `operation_time`, `create_by`) VALUES (17, 2, '分配角色权限', 2, '用户管理', '修改', '更新数据', 'http://127.0.0.1:8001/user/roles/4/permissions', 'POST', '[4,[]]', '{\"code\":200,\"message\":\"分配成功\",\"timestamp\":1753721616592}', '成功', 24, 'admin', 'SUPER_ADMIN', '127.0.0.1', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36', 5, NULL, NULL, '2025-07-29 00:53:37', 1, '2025-07-29 00:53:37', NULL, '%E7%B3%BB%E7%BB%9F%E7%AE%A1%E7%90%86%E5%91%98', '2025-07-29 00:53:37', 24);
INSERT INTO `sc_system_log` (`id`, `log_level`, `log_title`, `log_type`, `module_name`, `operation_name`, `operation_desc`, `request_url`, `request_method`, `request_params`, `response_data`, `response_result`, `user_id`, `username`, `user_type`, `ip_address`, `user_agent`, `execution_time`, `error_message`, `stack_trace`, `log_time`, `status`, `create_time`, `log_content`, `operator`, `operation_time`, `create_by`) VALUES (18, 2, '分配角色权限', 2, '用户管理', '修改', '更新数据', 'http://127.0.0.1:8001/user/roles/4/permissions', 'POST', '[4,[]]', '{\"code\":200,\"message\":\"分配成功\",\"timestamp\":1753721616592}', '成功', NULL, NULL, NULL, '127.0.0.1', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36', 5, NULL, NULL, '2025-07-29 00:53:37', 1, '2025-07-29 00:53:37', NULL, NULL, '2025-07-29 00:53:37', NULL);
INSERT INTO `sc_system_log` (`id`, `log_level`, `log_title`, `log_type`, `module_name`, `operation_name`, `operation_desc`, `request_url`, `request_method`, `request_params`, `response_data`, `response_result`, `user_id`, `username`, `user_type`, `ip_address`, `user_agent`, `execution_time`, `error_message`, `stack_trace`, `log_time`, `status`, `create_time`, `log_content`, `operator`, `operation_time`, `create_by`) VALUES (19, 2, '分配角色权限', 2, '用户管理', '修改', '更新数据', 'http://127.0.0.1:8001/user/roles/4/permissions', 'POST', '[4,[13001,13011,13061,13012,13041,13042,13043,13013,13051,13052,13053,13054,13014,13071,13015,13016,12073,13002,13021,13022,13023,13024,13025,13026,13027,12074,12075,12076,12077,12078,12079,12080,13003,13031,13032,13033,13034,13035,13036,13037,13038,12081,12082,12083,12084,12085,12086,13081,13082,13083,13084,13085,12087,12088,12089,12090,12091,12092,12093,12094,13091,12095,12096,12097,12098,12099,12100,12101,12102,12103,13092,12104,12105,12106,12107,12072,12132,12133,12134,12108,12109,12110,12111,12112,12113,12114,12115,12116,12117,12118,12119,12120,12121,12122,12123,12124,12125,12126,12127,12128,12129,12130,12131]]', '{\"code\":200,\"message\":\"分配成功\",\"timestamp\":1753722547225}', '成功', 24, 'admin', 'SUPER_ADMIN', '127.0.0.1', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36', 50, NULL, NULL, '2025-07-29 01:09:07', 1, '2025-07-29 01:09:07', NULL, '%E7%B3%BB%E7%BB%9F%E7%AE%A1%E7%90%86%E5%91%98', '2025-07-29 01:09:07', 24);
INSERT INTO `sc_system_log` (`id`, `log_level`, `log_title`, `log_type`, `module_name`, `operation_name`, `operation_desc`, `request_url`, `request_method`, `request_params`, `response_data`, `response_result`, `user_id`, `username`, `user_type`, `ip_address`, `user_agent`, `execution_time`, `error_message`, `stack_trace`, `log_time`, `status`, `create_time`, `log_content`, `operator`, `operation_time`, `create_by`) VALUES (20, 2, '创建楼栋', 2, '区域管理', '新增', '添加数据', 'http://192.168.0.101:8011/region/buildings', 'POST', '[{\"address\":\"123412341324132413241324132413241\",\"area\":100,\"buildingHeight\":50,\"buildingName\":\"阳光1幢\",\"buildingNo\":\"NO1\",\"buildingType\":2,\"communityId\":2,\"elevatorCount\":8,\"floorCount\":2,\"hasElevator\":1,\"landArea\":120,\"remark\":\"123423432\",\"status\":1,\"structureType\":1,\"undergroundFloor\":2,\"unitCount\":4,\"unitsPerFloor\":2}]', '{\"clientError\":false,\"code\":200,\"data\":true,\"message\":\"操作成功\",\"serverError\":false,\"success\":true,\"timestamp\":1754018536205}', '成功', 24, 'admin', 'SUPER_ADMIN', '192.168.0.101', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36', 59, NULL, NULL, '2025-08-01 11:22:16', 1, '2025-08-01 11:22:16', NULL, '%E7%B3%BB%E7%BB%9F%E7%AE%A1%E7%90%86%E5%91%98', '2025-08-01 11:22:16', 24);
INSERT INTO `sc_system_log` (`id`, `log_level`, `log_title`, `log_type`, `module_name`, `operation_name`, `operation_desc`, `request_url`, `request_method`, `request_params`, `response_data`, `response_result`, `user_id`, `username`, `user_type`, `ip_address`, `user_agent`, `execution_time`, `error_message`, `stack_trace`, `log_time`, `status`, `create_time`, `log_content`, `operator`, `operation_time`, `create_by`) VALUES (21, 2, '更新楼栋', 2, '区域管理', '修改', '更新数据', 'http://192.168.0.101:8011/region/buildings/9', 'PUT', '[9,{\"address\":\"3333333333333333333\",\"area\":100,\"buildingHeight\":50,\"buildingName\":\"阳光1幢\",\"buildingNo\":\"NO1\",\"buildingType\":2,\"communityId\":2,\"elevatorCount\":8,\"floorCount\":2,\"hasElevator\":1,\"landArea\":120,\"remark\":\"333333333333333333333333\",\"status\":1,\"structureType\":1,\"undergroundFloor\":2,\"unitCount\":4,\"unitsPerFloor\":2}]', '{\"clientError\":false,\"code\":200,\"data\":true,\"message\":\"操作成功\",\"serverError\":false,\"success\":true,\"timestamp\":1754018571886}', '成功', 24, 'admin', 'SUPER_ADMIN', '192.168.0.101', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36', 24, NULL, NULL, '2025-08-01 11:22:52', 1, '2025-08-01 11:22:52', NULL, '%E7%B3%BB%E7%BB%9F%E7%AE%A1%E7%90%86%E5%91%98', '2025-08-01 11:22:52', 24);
INSERT INTO `sc_system_log` (`id`, `log_level`, `log_title`, `log_type`, `module_name`, `operation_name`, `operation_desc`, `request_url`, `request_method`, `request_params`, `response_data`, `response_result`, `user_id`, `username`, `user_type`, `ip_address`, `user_agent`, `execution_time`, `error_message`, `stack_trace`, `log_time`, `status`, `create_time`, `log_content`, `operator`, `operation_time`, `create_by`) VALUES (22, 2, '更新楼栋', 2, '区域管理', '修改', '更新数据', 'http://192.168.0.101:8011/region/buildings/9', 'PUT', '[9,{\"address\":\"3333333333333333333\",\"area\":101,\"buildingHeight\":51,\"buildingName\":\"阳光1幢\",\"buildingNo\":\"NO1\",\"buildingType\":2,\"communityId\":2,\"elevatorCount\":8,\"floorCount\":2,\"hasElevator\":1,\"landArea\":121,\"remark\":\"333333333333333333333333\",\"status\":1,\"structureType\":1,\"undergroundFloor\":2,\"unitCount\":4,\"unitsPerFloor\":2}]', '{\"clientError\":false,\"code\":200,\"data\":true,\"message\":\"操作成功\",\"serverError\":false,\"success\":true,\"timestamp\":1754018579149}', '成功', 24, 'admin', 'SUPER_ADMIN', '192.168.0.101', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36', 12, NULL, NULL, '2025-08-01 11:22:59', 1, '2025-08-01 11:22:59', NULL, '%E7%B3%BB%E7%BB%9F%E7%AE%A1%E7%90%86%E5%91%98', '2025-08-01 11:22:59', 24);
INSERT INTO `sc_system_log` (`id`, `log_level`, `log_title`, `log_type`, `module_name`, `operation_name`, `operation_desc`, `request_url`, `request_method`, `request_params`, `response_data`, `response_result`, `user_id`, `username`, `user_type`, `ip_address`, `user_agent`, `execution_time`, `error_message`, `stack_trace`, `log_time`, `status`, `create_time`, `log_content`, `operator`, `operation_time`, `create_by`) VALUES (23, 2, '创建楼栋', 2, '区域管理', '新增', '添加数据', 'http://192.168.0.101:8011/region/buildings', 'POST', '[{\"address\":\"BBBBBBBBBBBBBBB\",\"area\":100,\"buildYear\":2020,\"buildingHeight\":100,\"buildingName\":\"阳光B\",\"buildingNo\":\"B\",\"buildingType\":4,\"communityId\":2,\"elevatorCount\":8,\"floorCount\":2,\"hasElevator\":1,\"landArea\":120,\"remark\":\"BBBBBBBBBBBB\",\"status\":1,\"structureType\":2,\"undergroundFloor\":1,\"unitCount\":4,\"unitsPerFloor\":2}]', '{\"clientError\":false,\"code\":200,\"data\":true,\"message\":\"操作成功\",\"serverError\":false,\"success\":true,\"timestamp\":1754022011971}', '成功', 24, 'admin', 'SUPER_ADMIN', '192.168.0.101', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36', 749, NULL, NULL, '2025-08-01 12:20:12', 1, '2025-08-01 12:20:12', NULL, '%E7%B3%BB%E7%BB%9F%E7%AE%A1%E7%90%86%E5%91%98', '2025-08-01 12:20:12', 24);
INSERT INTO `sc_system_log` (`id`, `log_level`, `log_title`, `log_type`, `module_name`, `operation_name`, `operation_desc`, `request_url`, `request_method`, `request_params`, `response_data`, `response_result`, `user_id`, `username`, `user_type`, `ip_address`, `user_agent`, `execution_time`, `error_message`, `stack_trace`, `log_time`, `status`, `create_time`, `log_content`, `operator`, `operation_time`, `create_by`) VALUES (24, 4, '更新房户', 2, '区域管理', '修改', '更新数据', 'http://192.168.0.101:8011/region/households/11', 'PUT', '[11,{\"area\":89.5,\"buildingId\":6,\"floorNumber\":1,\"householdCode\":\"102\",\"id\":11,\"propertyFeeRate\":2.5,\"propertyType\":1,\"roomNumber\":\"102\",\"roomType\":1,\"sortOrder\":0,\"status\":1,\"unitId\":5,\"usableArea\":6}]', NULL, '失败', 24, 'admin', 'SUPER_ADMIN', '192.168.0.101', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36', 62, '更新住户失败：住户编码已存在', '[Ljava.lang.StackTraceElement;@1462aeb5', '2025-08-01 14:01:02', 0, '2025-08-01 14:01:02', NULL, '%E7%B3%BB%E7%BB%9F%E7%AE%A1%E7%90%86%E5%91%98', '2025-08-01 14:01:02', 24);
INSERT INTO `sc_system_log` (`id`, `log_level`, `log_title`, `log_type`, `module_name`, `operation_name`, `operation_desc`, `request_url`, `request_method`, `request_params`, `response_data`, `response_result`, `user_id`, `username`, `user_type`, `ip_address`, `user_agent`, `execution_time`, `error_message`, `stack_trace`, `log_time`, `status`, `create_time`, `log_content`, `operator`, `operation_time`, `create_by`) VALUES (25, 2, '分配角色权限', 2, '用户管理', '修改', '更新数据', 'http://127.0.0.1:8001/user/roles/3/permissions', 'POST', '[3,[12073,12083,12084,12085,12135,12086,13091,13092,12090,12091,12092,12093,12094,12095,12096,12097,12098,12099,12100,12101,12102,12103,12104,12105,12106,12107,12108,12109,12110,12111,12112,12113,12114,12115,12117,12118,12120,12121,12122,12123,12124,12125,12126,12127,12081,12087,12116]]', '{\"code\":200,\"message\":\"分配成功\",\"timestamp\":1754057248804}', '成功', 24, 'admin', 'SUPER_ADMIN', '127.0.0.1', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36', 189, NULL, NULL, '2025-08-01 22:07:29', 1, '2025-08-01 22:07:29', NULL, '%E7%B3%BB%E7%BB%9F%E7%AE%A1%E7%90%86%E5%91%98', '2025-08-01 22:07:29', 24);
INSERT INTO `sc_system_log` (`id`, `log_level`, `log_title`, `log_type`, `module_name`, `operation_name`, `operation_desc`, `request_url`, `request_method`, `request_params`, `response_data`, `response_result`, `user_id`, `username`, `user_type`, `ip_address`, `user_agent`, `execution_time`, `error_message`, `stack_trace`, `log_time`, `status`, `create_time`, `log_content`, `operator`, `operation_time`, `create_by`) VALUES (26, 2, '分配角色权限', 2, '用户管理', '修改', '更新数据', 'http://127.0.0.1:8001/user/roles/4/permissions', 'POST', '[4,[]]', '{\"code\":200,\"message\":\"分配成功\",\"timestamp\":1754149072392}', '成功', 24, 'admin', 'SUPER_ADMIN', '127.0.0.1', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36', 793, NULL, NULL, '2025-08-02 23:37:52', 1, '2025-08-02 23:37:52', NULL, '%E7%B3%BB%E7%BB%9F%E7%AE%A1%E7%90%86%E5%91%98', '2025-08-02 23:37:52', 24);
INSERT INTO `sc_system_log` (`id`, `log_level`, `log_title`, `log_type`, `module_name`, `operation_name`, `operation_desc`, `request_url`, `request_method`, `request_params`, `response_data`, `response_result`, `user_id`, `username`, `user_type`, `ip_address`, `user_agent`, `execution_time`, `error_message`, `stack_trace`, `log_time`, `status`, `create_time`, `log_content`, `operator`, `operation_time`, `create_by`) VALUES (27, 2, '分配角色权限', 2, '用户管理', '修改', '更新数据', 'http://127.0.0.1:8001/user/roles/4/permissions', 'POST', '[4,[13001,13011,13061,13012,13041,13042,13043,13013,13051,13052,13053,13054,13014,13071,13015,13016,12073,13002,13021,13022,13023,13024,13025,13026,13027,12074,12075,12076,12077,12078,12079,12080,13003,13031,13032,13033,13034,13035,13036,13037,13038,12081,12082,12083,12084,12085,12135,12086,13081,13082,13083,13084,13085,13091,13092,12072,12132,12133,12134,12087,12088,12089,12090,12091,12092,12093,12094,12095,12096,12097,12098,12099,12100,12101,12102,12103,12104,12105,12106,12107,12108,12109,12110,12111,12112,12113,12114,12115,12116,12117,12118,12119,12120,12121,12122,12123,12124,12125,12126,12127,12128,12129,12130,12131]]', '{\"code\":200,\"message\":\"分配成功\",\"timestamp\":1754149192530}', '成功', 24, 'admin', 'SUPER_ADMIN', '127.0.0.1', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36', 214, NULL, NULL, '2025-08-02 23:39:53', 1, '2025-08-02 23:39:53', NULL, '%E7%B3%BB%E7%BB%9F%E7%AE%A1%E7%90%86%E5%91%98', '2025-08-02 23:39:53', 24);
INSERT INTO `sc_system_log` (`id`, `log_level`, `log_title`, `log_type`, `module_name`, `operation_name`, `operation_desc`, `request_url`, `request_method`, `request_params`, `response_data`, `response_result`, `user_id`, `username`, `user_type`, `ip_address`, `user_agent`, `execution_time`, `error_message`, `stack_trace`, `log_time`, `status`, `create_time`, `log_content`, `operator`, `operation_time`, `create_by`) VALUES (28, 2, '分配用户角色', 2, '用户管理', '修改', '更新数据', 'http://127.0.0.1:8001/user/role/assign/1', 'POST', '[1,[1]]', '{\"clientError\":false,\"code\":200,\"message\":\"操作成功\",\"serverError\":false,\"success\":true,\"timestamp\":1754150109222}', '成功', 24, 'admin', 'SUPER_ADMIN', '127.0.0.1', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36', 133, NULL, NULL, '2025-08-02 23:55:09', 1, '2025-08-02 23:55:09', NULL, '%E7%B3%BB%E7%BB%9F%E7%AE%A1%E7%90%86%E5%91%98', '2025-08-02 23:55:09', 24);
INSERT INTO `sc_system_log` (`id`, `log_level`, `log_title`, `log_type`, `module_name`, `operation_name`, `operation_desc`, `request_url`, `request_method`, `request_params`, `response_data`, `response_result`, `user_id`, `username`, `user_type`, `ip_address`, `user_agent`, `execution_time`, `error_message`, `stack_trace`, `log_time`, `status`, `create_time`, `log_content`, `operator`, `operation_time`, `create_by`) VALUES (29, 2, '分配用户角色', 2, '用户管理', '修改', '更新数据', 'http://127.0.0.1:8001/user/role/assign/1', 'POST', '[1,[9]]', '{\"clientError\":false,\"code\":200,\"message\":\"操作成功\",\"serverError\":false,\"success\":true,\"timestamp\":1754150124314}', '成功', 24, 'admin', 'SUPER_ADMIN', '127.0.0.1', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36', 47, NULL, NULL, '2025-08-02 23:55:24', 1, '2025-08-02 23:55:24', NULL, '%E7%B3%BB%E7%BB%9F%E7%AE%A1%E7%90%86%E5%91%98', '2025-08-02 23:55:24', 24);
INSERT INTO `sc_system_log` (`id`, `log_level`, `log_title`, `log_type`, `module_name`, `operation_name`, `operation_desc`, `request_url`, `request_method`, `request_params`, `response_data`, `response_result`, `user_id`, `username`, `user_type`, `ip_address`, `user_agent`, `execution_time`, `error_message`, `stack_trace`, `log_time`, `status`, `create_time`, `log_content`, `operator`, `operation_time`, `create_by`) VALUES (30, 4, '新增住户信息', 2, '区域管理', '新增', '添加数据', 'http://192.168.0.101:8011/region/residents', 'POST', '[{\"birthday\":\"1985-08-05\",\"buildingId\":6,\"communityId\":5,\"education\":\"本科\",\"email\":\"369222136@qq.com\",\"emergencyContact\":\"小毛毛\",\"emergencyPhone\":\"110\",\"gender\":1,\"householdId\":10,\"identityNo\":\"330184198511181815\",\"identityType\":1,\"moveInDate\":\"2018-01-01\",\"nativePlace\":\"杭州\",\"petInfo\":\"小橘子\",\"phone\":\"13567114714\",\"profession\":\"abc\",\"realName\":\"吴樑\",\"remark\":\"无备注\",\"residentType\":1,\"specialNeeds\":\"没有\",\"status\":1,\"unitId\":5,\"vehicleInfo\":\"浙AAAAAAA\",\"workUnit\":\"cba\"}]', NULL, '失败', 9, 'gufeiya', 'PROPERTY_ADMIN', '192.168.0.101', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36', 25, '[500] during [GET] to [http://smart-community-user/feign/user/user/info/idcard/330184198511181815] [UserFeignService#getUserByIdCard(String)]: [{\"code\":500,\"message\":\"系统内部错误，请联系管理员\",\"timestamp\":1754361364097,\"success\":false,\"clientError\":false,\"serverError\":true}]', '[Ljava.lang.StackTraceElement;@76e9e0ca', '2025-08-05 10:36:04', 0, '2025-08-05 10:36:04', NULL, '%E6%99%BA%E6%85%A7%E7%89%A9%E4%B8%9A%E7%AE%A1%E7%90%86%E5%91%98', '2025-08-05 10:36:04', 9);
INSERT INTO `sc_system_log` (`id`, `log_level`, `log_title`, `log_type`, `module_name`, `operation_name`, `operation_desc`, `request_url`, `request_method`, `request_params`, `response_data`, `response_result`, `user_id`, `username`, `user_type`, `ip_address`, `user_agent`, `execution_time`, `error_message`, `stack_trace`, `log_time`, `status`, `create_time`, `log_content`, `operator`, `operation_time`, `create_by`) VALUES (31, 4, '新增住户信息', 2, '区域管理', '新增', '添加数据', 'http://192.168.0.101:8011/region/residents', 'POST', '[{\"birthday\":\"1985-08-05\",\"buildingId\":6,\"communityId\":5,\"education\":\"本科\",\"email\":\"369222136@qq.com\",\"emergencyContact\":\"小毛毛\",\"emergencyPhone\":\"110\",\"gender\":1,\"householdId\":10,\"identityNo\":\"330184198511181815\",\"identityType\":1,\"moveInDate\":\"2018-01-01\",\"nativePlace\":\"杭州\",\"petInfo\":\"小橘子\",\"phone\":\"13567114714\",\"profession\":\"abc\",\"realName\":\"吴樑\",\"remark\":\"无备注\",\"residentType\":1,\"specialNeeds\":\"没有\",\"status\":1,\"unitId\":5,\"vehicleInfo\":\"浙AAAAAAA\",\"workUnit\":\"cba\"}]', NULL, '失败', 9, 'gufeiya', 'PROPERTY_ADMIN', '192.168.0.101', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36', 148, '[500] during [GET] to [http://smart-community-user/feign/user/user/info/idcard/330184198511181815] [UserFeignService#getUserByIdCard(String)]: [{\"code\":500,\"message\":\"系统内部错误，请联系管理员\",\"timestamp\":1754361842356,\"success\":false,\"clientError\":false,\"serverError\":true}]', '[Ljava.lang.StackTraceElement;@4756ba55', '2025-08-05 10:44:02', 0, '2025-08-05 10:44:02', NULL, '%E6%99%BA%E6%85%A7%E7%89%A9%E4%B8%9A%E7%AE%A1%E7%90%86%E5%91%98', '2025-08-05 10:44:02', 9);
INSERT INTO `sc_system_log` (`id`, `log_level`, `log_title`, `log_type`, `module_name`, `operation_name`, `operation_desc`, `request_url`, `request_method`, `request_params`, `response_data`, `response_result`, `user_id`, `username`, `user_type`, `ip_address`, `user_agent`, `execution_time`, `error_message`, `stack_trace`, `log_time`, `status`, `create_time`, `log_content`, `operator`, `operation_time`, `create_by`) VALUES (32, 4, '新增住户信息', 2, '区域管理', '新增', '添加数据', 'http://192.168.0.101:8011/region/residents', 'POST', '[{\"birthday\":\"1985-08-05\",\"buildingId\":6,\"communityId\":5,\"education\":\"本科\",\"email\":\"369222136@qq.com\",\"emergencyContact\":\"小毛毛\",\"emergencyPhone\":\"110\",\"gender\":1,\"householdId\":10,\"identityNo\":\"330184198511181815\",\"identityType\":1,\"moveInDate\":\"2018-01-01\",\"nativePlace\":\"杭州\",\"petInfo\":\"小橘子\",\"phone\":\"13567114714\",\"profession\":\"abc\",\"realName\":\"吴樑\",\"remark\":\"无备注\",\"residentType\":1,\"specialNeeds\":\"没有\",\"status\":1,\"unitId\":5,\"vehicleInfo\":\"浙AAAAAAA\",\"workUnit\":\"cba\"}]', NULL, '失败', 9, 'gufeiya', 'PROPERTY_ADMIN', '192.168.0.101', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36', 25, '[500] during [GET] to [http://smart-community-user/feign/user/user/info/idcard/330184198511181815] [UserFeignService#getUserByIdCard(String)]: [{\"code\":500,\"message\":\"系统内部错误，请联系管理员\",\"timestamp\":1754361913455,\"success\":false,\"clientError\":false,\"serverError\":true}]', '[Ljava.lang.StackTraceElement;@6ab2fc91', '2025-08-05 10:45:13', 0, '2025-08-05 10:45:13', NULL, '%E6%99%BA%E6%85%A7%E7%89%A9%E4%B8%9A%E7%AE%A1%E7%90%86%E5%91%98', '2025-08-05 10:45:13', 9);
INSERT INTO `sc_system_log` (`id`, `log_level`, `log_title`, `log_type`, `module_name`, `operation_name`, `operation_desc`, `request_url`, `request_method`, `request_params`, `response_data`, `response_result`, `user_id`, `username`, `user_type`, `ip_address`, `user_agent`, `execution_time`, `error_message`, `stack_trace`, `log_time`, `status`, `create_time`, `log_content`, `operator`, `operation_time`, `create_by`) VALUES (33, 4, '新增住户信息', 2, '区域管理', '新增', '添加数据', 'http://192.168.0.101:8011/region/residents', 'POST', '[{\"birthday\":\"1985-08-05\",\"buildingId\":6,\"communityId\":5,\"education\":\"本科\",\"email\":\"369222136@qq.com\",\"emergencyContact\":\"小毛毛\",\"emergencyPhone\":\"110\",\"gender\":1,\"householdId\":10,\"identityNo\":\"330184198511181815\",\"identityType\":1,\"moveInDate\":\"2018-01-01\",\"nativePlace\":\"杭州\",\"petInfo\":\"小橘子\",\"phone\":\"13567114714\",\"profession\":\"abc\",\"realName\":\"吴樑\",\"remark\":\"无备注\",\"residentType\":1,\"specialNeeds\":\"没有\",\"status\":1,\"unitId\":5,\"vehicleInfo\":\"浙AAAAAAA\",\"workUnit\":\"cba\"}]', NULL, '失败', 9, 'gufeiya', 'PROPERTY_ADMIN', '192.168.0.101', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36', 173, '[404] during [POST] to [http://smart-community-user/feign/user/user/update] [UserFeignService#updateUser(UserDTO)]: [{\"error\":\"Not Found\",\"path\":\"/feign/user/user/update\",\"status\":404,\"timestamp\":\"2025-08-05T02:52:51.081+00:00\"}]', '[Ljava.lang.StackTraceElement;@1c4c8a67', '2025-08-05 10:52:51', 0, '2025-08-05 10:52:51', NULL, '%E6%99%BA%E6%85%A7%E7%89%A9%E4%B8%9A%E7%AE%A1%E7%90%86%E5%91%98', '2025-08-05 10:52:51', 9);
INSERT INTO `sc_system_log` (`id`, `log_level`, `log_title`, `log_type`, `module_name`, `operation_name`, `operation_desc`, `request_url`, `request_method`, `request_params`, `response_data`, `response_result`, `user_id`, `username`, `user_type`, `ip_address`, `user_agent`, `execution_time`, `error_message`, `stack_trace`, `log_time`, `status`, `create_time`, `log_content`, `operator`, `operation_time`, `create_by`) VALUES (34, 2, '新增住户信息', 2, '区域管理', '新增', '添加数据', 'http://192.168.0.101:8011/region/residents', 'POST', '[{\"birthday\":\"1985-08-05\",\"buildingId\":6,\"communityId\":5,\"education\":\"本科\",\"email\":\"369222136@qq.com\",\"emergencyContact\":\"小毛毛\",\"emergencyPhone\":\"110\",\"gender\":1,\"householdId\":10,\"identityNo\":\"330184198511181815\",\"identityType\":1,\"moveInDate\":\"2018-01-01\",\"nativePlace\":\"杭州\",\"petInfo\":\"小橘子\",\"phone\":\"13567114714\",\"profession\":\"abc\",\"realName\":\"吴樑\",\"remark\":\"无备注\",\"residentType\":1,\"specialNeeds\":\"没有\",\"status\":1,\"unitId\":5,\"vehicleInfo\":\"浙AAAAAAA\",\"workUnit\":\"cba\"}]', '{\"clientError\":false,\"code\":200,\"data\":{\"birthday\":\"1985-08-05\",\"createBy\":9,\"createTime\":\"2025-08-05T11:00:07.872\",\"education\":\"本科\",\"email\":\"369222136@qq.com\",\"emergencyContact\":\"小毛毛\",\"emergencyPhone\":\"110\",\"gender\":1,\"id\":1952565252952600577,\"identityNo\":\"330184198511181815\",\"identityType\":1,\"nativePlace\":\"杭州\",\"petInfo\":\"小橘子\",\"phone\":\"13567114714\",\"profession\":\"abc\",\"realName\":\"吴樑\",\"remark\":\"无备注\",\"specialNeeds\":\"没有\",\"status\":1,\"updateBy\":9,\"updateTime\":\"2025-08-05T11:00:07.876\",\"userId\":1,\"vehicleInfo\":\"浙AAAAAAA\",\"workUnit\":\"cba\"},\"message\":\"操作成功\",\"serverError\":false,\"success\":true,\"timestamp\":1754362807905}', '成功', 9, 'gufeiya', 'PROPERTY_ADMIN', '192.168.0.101', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36', 481, NULL, NULL, '2025-08-05 11:00:08', 1, '2025-08-05 11:00:08', NULL, '%E6%99%BA%E6%85%A7%E7%89%A9%E4%B8%9A%E7%AE%A1%E7%90%86%E5%91%98', '2025-08-05 11:00:08', 9);
INSERT INTO `sc_system_log` (`id`, `log_level`, `log_title`, `log_type`, `module_name`, `operation_name`, `operation_desc`, `request_url`, `request_method`, `request_params`, `response_data`, `response_result`, `user_id`, `username`, `user_type`, `ip_address`, `user_agent`, `execution_time`, `error_message`, `stack_trace`, `log_time`, `status`, `create_time`, `log_content`, `operator`, `operation_time`, `create_by`) VALUES (35, 4, '新增住户信息', 2, '区域管理', '新增', '添加数据', 'http://192.168.0.101:8011/region/residents', 'POST', '[{\"birthday\":\"2016-11-07\",\"buildingId\":6,\"communityId\":5,\"education\":\"小学\",\"email\":\"2565760135@qq.com\",\"gender\":1,\"householdId\":10,\"identityNo\":\"330184201611071815\",\"identityType\":1,\"moveInDate\":\"2025-08-01\",\"nativePlace\":\"杭州\",\"phone\":\"13567114715\",\"profession\":\"小学僧\",\"realName\":\"小毛毛\",\"residentType\":2,\"status\":1,\"unitId\":5,\"workUnit\":\"一小\"}]', NULL, '失败', 9, 'gufeiya', 'PROPERTY_ADMIN', '192.168.0.101', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36', 122, '[500] during [POST] to [http://smart-community-user/feign/user/user/create/normal] [UserFeignService#createNormalUser(Map)]: [{\"code\":500,\"message\":\"系统内部错误，请联系管理员\",\"timestamp\":1754363207836,\"success\":false,\"clientError\":false,\"serverError\":true}]', '[Ljava.lang.StackTraceElement;@29f244f4', '2025-08-05 11:06:48', 0, '2025-08-05 11:06:48', NULL, '%E6%99%BA%E6%85%A7%E7%89%A9%E4%B8%9A%E7%AE%A1%E7%90%86%E5%91%98', '2025-08-05 11:06:48', 9);
INSERT INTO `sc_system_log` (`id`, `log_level`, `log_title`, `log_type`, `module_name`, `operation_name`, `operation_desc`, `request_url`, `request_method`, `request_params`, `response_data`, `response_result`, `user_id`, `username`, `user_type`, `ip_address`, `user_agent`, `execution_time`, `error_message`, `stack_trace`, `log_time`, `status`, `create_time`, `log_content`, `operator`, `operation_time`, `create_by`) VALUES (36, 2, '新增住户信息', 2, '区域管理', '新增', '添加数据', 'http://192.168.0.101:8011/region/residents', 'POST', '[{\"birthday\":\"2016-11-07\",\"buildingId\":6,\"communityId\":5,\"education\":\"小学\",\"email\":\"2565760135@qq.com\",\"gender\":1,\"householdId\":10,\"identityNo\":\"330184201611071815\",\"identityType\":1,\"moveInDate\":\"2025-08-01\",\"nativePlace\":\"杭州\",\"phone\":\"13567114715\",\"profession\":\"小学僧\",\"realName\":\"小毛毛\",\"residentType\":2,\"status\":1,\"unitId\":5,\"workUnit\":\"一小\"}]', '{\"clientError\":false,\"code\":200,\"data\":{\"birthday\":\"2016-11-07\",\"createBy\":9,\"createTime\":\"2025-08-05T11:15:13.957\",\"education\":\"小学\",\"email\":\"2565760135@qq.com\",\"gender\":1,\"id\":1952569053361123330,\"identityNo\":\"330184201611071815\",\"identityType\":1,\"nativePlace\":\"杭州\",\"phone\":\"13567114715\",\"profession\":\"小学僧\",\"realName\":\"小毛毛\",\"status\":1,\"updateBy\":9,\"updateTime\":\"2025-08-05T11:15:13.957\",\"userId\":1952569052660666370,\"workUnit\":\"一小\"},\"message\":\"操作成功\",\"serverError\":false,\"success\":true,\"timestamp\":1754363713964}', '成功', 9, 'gufeiya', 'PROPERTY_ADMIN', '192.168.0.101', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36', 308, NULL, NULL, '2025-08-05 11:15:14', 1, '2025-08-05 11:15:14', NULL, '%E6%99%BA%E6%85%A7%E7%89%A9%E4%B8%9A%E7%AE%A1%E7%90%86%E5%91%98', '2025-08-05 11:15:14', 9);
INSERT INTO `sc_system_log` (`id`, `log_level`, `log_title`, `log_type`, `module_name`, `operation_name`, `operation_desc`, `request_url`, `request_method`, `request_params`, `response_data`, `response_result`, `user_id`, `username`, `user_type`, `ip_address`, `user_agent`, `execution_time`, `error_message`, `stack_trace`, `log_time`, `status`, `create_time`, `log_content`, `operator`, `operation_time`, `create_by`) VALUES (37, 2, '新增住户信息', 2, '区域管理', '新增', '添加数据', 'http://192.168.0.101:8011/region/residents', 'POST', '[{\"birthday\":\"2020-08-05\",\"buildingId\":6,\"communityId\":5,\"education\":\"小学\",\"email\":\"18329188129@139.com\",\"gender\":2,\"householdId\":10,\"identityNo\":\"330184198511181814\",\"identityType\":1,\"moveInDate\":\"2025-08-01\",\"nativePlace\":\"杭州\",\"phone\":\"18329188129\",\"profession\":\"小学生\",\"realName\":\"小呱呱\",\"remark\":\"无\",\"residentType\":4,\"status\":1,\"unitId\":5,\"workUnit\":\"塘栖一小\"}]', '{\"clientError\":false,\"code\":200,\"data\":{\"birthday\":\"2020-08-05\",\"createBy\":24,\"createTime\":\"2025-08-05T11:32:09.912\",\"education\":\"小学\",\"email\":\"18329188129@139.com\",\"gender\":2,\"id\":1952573314581049346,\"identityNo\":\"330184198511181814\",\"identityType\":1,\"nativePlace\":\"杭州\",\"phone\":\"18329188129\",\"profession\":\"小学生\",\"realName\":\"小呱呱\",\"remark\":\"无\",\"status\":1,\"updateBy\":24,\"updateTime\":\"2025-08-05T11:32:09.912\",\"userId\":32,\"workUnit\":\"塘栖一小\"},\"message\":\"操作成功\",\"serverError\":false,\"success\":true,\"timestamp\":1754364729932}', '成功', 24, 'admin', 'SUPER_ADMIN', '192.168.0.101', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36', 183, NULL, NULL, '2025-08-05 11:32:10', 1, '2025-08-05 11:32:10', NULL, '%E7%B3%BB%E7%BB%9F%E7%AE%A1%E7%90%86%E5%91%98', '2025-08-05 11:32:10', 24);
INSERT INTO `sc_system_log` (`id`, `log_level`, `log_title`, `log_type`, `module_name`, `operation_name`, `operation_desc`, `request_url`, `request_method`, `request_params`, `response_data`, `response_result`, `user_id`, `username`, `user_type`, `ip_address`, `user_agent`, `execution_time`, `error_message`, `stack_trace`, `log_time`, `status`, `create_time`, `log_content`, `operator`, `operation_time`, `create_by`) VALUES (38, 2, '删除物业公司', 2, '物业管理', '删除', '删除数据', 'http://192.168.0.101:8003/property/companies/2', 'DELETE', '[2]', '{\"clientError\":false,\"code\":200,\"message\":\"操作成功\",\"serverError\":false,\"success\":true,\"timestamp\":1754530526678}', '成功', 9, 'gufeiya', 'PROPERTY_ADMIN', '192.168.0.101', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36', 21, NULL, NULL, '2025-08-07 09:35:27', 1, '2025-08-07 09:35:27', NULL, '%E6%99%BA%E6%85%A7%E7%89%A9%E4%B8%9A%E7%AE%A1%E7%90%86%E5%91%98', '2025-08-07 09:35:27', 9);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
